package pv.dao.table;

import android.provider.BaseColumns;

public abstract class CountryTable implements BaseColumns {
	public static final String TABLE_NAME = "country";
//	public static final String COUNTRY_ID = "country_id";
	public static final String NAME = "name";

	private static final String TEXT_TYPE = " TEXT";
	private static final String LONG_TYPE = " LONG";
	private static final String INT_TYPE = " INTEGER";
	private static final String COMMA_SEP = ",";

	// public static final String SQL_CREATE_ENTRIES = "CREATE TABLE "
	// + TABLE_NAME + " (" + _ID + " INTEGER PRIMARY KEY," + COUNTRY_ID
	// + INT_TYPE + COMMA_SEP + NAME + TEXT_TYPE + " )";

	public static final String SQL_CREATE_ENTRIES = "CREATE TABLE "
			+ TABLE_NAME + " (" + _ID + " INTEGER PRIMARY KEY," /*
																 * + COUNTRY_ID
																 * + INT_TYPE +
																 * COMMA_SEP
																 */ + NAME + TEXT_TYPE + " )";

	public static final String SQL_DELETE_ENTRIES = "DROP TABLE IF EXISTS "
			+ TABLE_NAME;

}
